Mega Code Archive
Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial
Oracle PLSQL
1) Aggregate Functions
2) Analytical Functions
3) Char Functions
4) Constraints
5) Conversion Functions
6) Cursor
7) Data Type
8) Date Timezone
9) Hierarchical Query
10) Index
11) Insert Delete Update
12) Large Objects
13) Numeric Math Functions
14) Object Oriented Database
15) PL SQL
16) Regular Expressions
17) Report Column Page
18) Result Set
19) Select Query
20) Sequence
21) SQL Plus
22) Stored Procedure Function
23) Subquery
24) System Packages
25) System Tables Views
26) Table
27) Table Joins
28) Trigger
29) User Previliege
30) View
31) XML
Table Joins
1) 3-Way join
2) A left outer join
3) Add the USING clause
4) Adding an Analytical Function to a Query that Contains a Join (and Other WHERE Conditions)
5) Adding Ordering to the Query Containing the GROUP BY
6) An inner join to
7) Cartesian Products in action
8) Cross joins Demo
9) Demo the ANSI outer join
10) Demonstrate a FULL outer join
11) Full outer join Demo
12) Get Categories and Products (with Alternate Join Syntax)
13) Get Categories and Products (with Joins)
14) Group by and right join department id
15) How Many Featured Products By Department with JOINs
16) How Many Products By Department with JOINs
17) Inner and Outer Joins
18) Inner and Outer Joins(room and class)
19) Inner join primary key and foreign key
20) Inner join with null foreign key
21) Inner joins use join conditions in the FROM clause just like natural joins
22) Join and GROUP BY
23) Join columns with full table name reference
24) Join table using
25) Join three table to find out which employee sold that gift
26) Join two tables
27) Join using and join on
28) Join using clause
29) Join with (+)
30) Join with a subquery
31) Joining table to use between and clause
32) Left join with plus sign
33) LEFT OUTER JOIN tableName ON joined columns
34) LEFT OUTER JOIN vs RIGHT OUTER JOIN
35) Left outer join between employee table and department table
36) Left outer join demo
37) Natural join 2
38) Natural join Demo
39) Nested Multi-Table Equi-Joins
40) Non-Equi Joins
41) Outer Joins demo
42) Performing Cross Joins Using SQL92
43) Performing Full Outer Joins Using SQL92
44) Performing Left Outer Joins Using SQL92
45) Performing Right Outer Joins Using SQL92
46) Performing Self Joins Using SQL92
47) Reference inner query column in outter select statement
48) Right join with where in clause
49) Right outer join
50) Right outer join between department table and employee table
51) Right Outer Join(room vs class)
52) Right Outer Join, room table and class table
53) Right outer joins
54) Self join for employees and their managers
55) Supplying Table Aliases
56) The query shows that the join is performed with the other WHERE conditions
57) Three inner joins query
58) Two join on clauses
59) Two Table Equi-Joins for ids
60) Two Table Equi-Joins with where clause and order by clause
61) Two Table Equi-Joins(join on)
62) Understanding Outer Joins
63) Understanding Self Joins
64) Use a Cartesian productvirtual table like this
65) Use an ANSI outer join and use the NVL function to convert nulls to the string NA
66) Use column name alias during table join
67) Use in operator with table join
68) Used a GROUP BY in a query with no ordering or analytical function
69) Using AVG in an analytical function
70) Using Inner Joins
71) Using Natural Joins sql
72) Working with equijoins